CREATE TABLE [dbo].[Participant]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[Name] [nchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [nchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Mobile] [nchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone] [nchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SchoolId] [int] NOT NULL,
[EventId] [int] NOT NULL,
[InterviewTime] [date] NULL,
[PST] [date] NULL,
[Comment] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[Participant] ADD
CONSTRAINT [FK_Participant_College] FOREIGN KEY ([Id]) REFERENCES [dbo].[College] ([Id])
ALTER TABLE [dbo].[Participant] ADD
CONSTRAINT [FK_Participant_Event] FOREIGN KEY ([Id]) REFERENCES [dbo].[Event] ([Id])
GO
ALTER TABLE [dbo].[Participant] ADD CONSTRAINT [PK_Participant] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
